PowerTools SPREAD for Windows Forms 10.0J
SetConditionalFormatting(Int32,Int32,Int32,Int32,IConditionalFormattingRule[]) メソッド


行の開始インデックス
列の開始インデックス
行数
列数
指定したセル範囲に適用するルール。
指定したルールに基づいて、シートの指定したセル範囲に条件付き書式を設定します。
構文
'Declaration
 
Public Overloads Sub SetConditionalFormatting( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer, _
   ByVal ParamArray rules() As IConditionalFormattingRule _
) 
'使用法
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim rules() As IConditionalFormattingRule
 
instance.SetConditionalFormatting(row, column, rowCount, columnCount, rules)
public void SetConditionalFormatting( 
   int row,
   int column,
   int rowCount,
   int columnCount,
   params IConditionalFormattingRule[] rules
)

パラメータ

row
行の開始インデックス
column
列の開始インデックス
rowCount
行数
columnCount
列数
rules
指定したセル範囲に適用するルール。
次のサンプルコードは、条件付き規則を作成します。
private void Form1_Load(object sender, EventArgs e)
        {
            fpSpread1.Sheets[0].Cells[0, 0].Value = 3;
            fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
            fpSpread1.Sheets[0].Cells[1, 1].Value = 10;
            fpSpread1.Sheets[0].Cells[0, 2].Value = 1;            
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //Unique or Duplicate CF
            FarPoint.Win.Spread.UniqueOrDuplicatedConditionalFormattingRule ud = new FarPoint.Win.Spread.UniqueOrDuplicatedConditionalFormattingRule(false);
            ud.IsUnique = true;
            ud.BackColor = Color.Thistle;
            fpSpread1.ActiveSheet.SetConditionalFormatting(0,0,3,3, ud);
        }
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        FpSpread1.Sheets(0).Cells(0, 0).Value = 3
        FpSpread1.Sheets(0).Cells(1, 0).Value = 2
        FpSpread1.Sheets(0).Cells(1, 1).Value = 10
        FpSpread1.Sheets(0).Cells(0, 2).Value = 1
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        'Unique or Duplicate CF
        Dim ud = New FarPoint.Win.Spread.UniqueOrDuplicatedConditionalFormattingRule(False)
        ud.IsUnique = True
        ud.BackColor = Color.Thistle
        FpSpread1.ActiveSheet.SetConditionalFormatting(0, 0, 3, 3, ud)
    End Sub
参照

SheetView クラス
SheetView メンバ
オーバーロード一覧

 

 


© 2004-2017, GrapeCity inc. All rights reserved.